Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashgupta
Starting Member
17 Posts |
 Posted - 2009-02-11 : 17:43:57
|
| Hi Experts, I am having issues every now and then with exception on sql server 2005 when i try to insert a record [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.kindly help strange thing is when i rerun the same code and query on its own, it works fine |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-11 : 18:12:03
|
Do you have DATAWRITER permissions to the table?Have you checked the connection string that you are using the correct server?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
ashgupta
Starting Member
17 Posts |
Posted - 2009-02-11 : 18:23:50
|
| yes i do have data writter permission on this and connection string is also correct |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-11 : 18:25:18
|
Which application is throwing the error?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-11 : 18:26:23
|
Also show the insert statement you use.Sometimes when using odbc-specific function you get this error. If this is the case, use a t-sql syntax for insert statement.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
ashgupta
Starting Member
17 Posts |
Posted - 2009-02-11 : 18:26:39
|
| i am using VB.Net as front end |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-11 : 18:28:09
|
Also show the insert statement you use.If you are using VB.Net try to change the db library to Native Client in favor of ODBC.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
SQL SERVER 2005 - Exception Error