Click here to Skip to main content
15,941,690 members
Home / Discussions / Database
   

Database

 
AnswerRe: help me please [modified] Pin
meeram3959-Jul-08 0:41
meeram3959-Jul-08 0:41 
QuestionSending XML as input to Oracle stored procedure Pin
kalyan_vb8-Jul-08 23:48
kalyan_vb8-Jul-08 23:48 
Questiondefault settings SQL Server does not allow remote connections. Pin
Amit Agarrwal8-Jul-08 23:19
Amit Agarrwal8-Jul-08 23:19 
AnswerRe: default settings SQL Server does not allow remote connections. Pin
subai9-Jul-08 2:59
subai9-Jul-08 2:59 
QuestionHow to find the Table exists in a Data Base Pin
pallaka8-Jul-08 22:16
pallaka8-Jul-08 22:16 
AnswerRe: How to find the Table exists in a Data Base Pin
Ashfield8-Jul-08 22:47
Ashfield8-Jul-08 22:47 
GeneralRe: How to find the Table exists in a Data Base Pin
TheFM2349-Jul-08 4:46
TheFM2349-Jul-08 4:46 
QuestionChanging between mssql and access through connection string Pin
Y_R8-Jul-08 22:10
Y_R8-Jul-08 22:10 
Hi,

I have a c# (.Net 2) program that connects to access mdb file.
I use strong typed dataset to do this.

Now I have searched the web and found ms sql connection string
I replaced what was generated by the wizard with the new one and
now I can successfully connect to MS SQL server (with the same table).

The problem starts when I try to delete rows from the table.
In access it works great obviously, But with MS SQL I get exception when calling udpate (Wrong syntax near '.').

Is it possible at all to use strong typed datasets to connect to both MS SQL and ACESS. If yes how?

Thanks,
Yaniv
AnswerRe: Changing between mssql and access through connection string Pin
Mycroft Holmes9-Jul-08 17:36
professionalMycroft Holmes9-Jul-08 17:36 
GeneralRe: Changing between mssql and access through connection string Pin
Y_R12-Jul-08 21:40
Y_R12-Jul-08 21:40 
GeneralRe: Changing between mssql and access through connection string Pin
Mycroft Holmes13-Jul-08 12:39
professionalMycroft Holmes13-Jul-08 12:39 
GeneralRe: Changing between mssql and access through connection string Pin
Y_R13-Jul-08 22:53
Y_R13-Jul-08 22:53 
QuestionHow Can I Do This Select Statment Pin
Zeyad Jalil8-Jul-08 20:58
professionalZeyad Jalil8-Jul-08 20:58 
AnswerRe: How Can I Do This Select Statment Pin
Ashfield8-Jul-08 21:58
Ashfield8-Jul-08 21:58 
GeneralRe: How Can I Do This Select Statment Pin
Andy_L_J9-Jul-08 0:39
Andy_L_J9-Jul-08 0:39 
Questionnormalization terms Pin
Pankaj Garg8-Jul-08 19:18
Pankaj Garg8-Jul-08 19:18 
AnswerRe: normalization terms [modified] Pin
leoinfo9-Jul-08 4:08
leoinfo9-Jul-08 4:08 
QuestionMS Access Connection String Pin
kadkir8-Jul-08 17:41
kadkir8-Jul-08 17:41 
AnswerRe: MS Access Connection String Pin
Jack Brando8-Jul-08 19:19
Jack Brando8-Jul-08 19:19 
GeneralRe: MS Access Connection String Pin
kadkir8-Jul-08 19:35
kadkir8-Jul-08 19:35 
GeneralRe: MS Access Connection String Pin
Mycroft Holmes9-Jul-08 17:44
professionalMycroft Holmes9-Jul-08 17:44 
QuestionMS SQL Server Multiple Roles per User Pin
Jack Brando8-Jul-08 17:34
Jack Brando8-Jul-08 17:34 
AnswerRe: MS SQL Server Multiple Roles per User Pin
Ashfield8-Jul-08 22:03
Ashfield8-Jul-08 22:03 
QuestionCommunicating via Windows Service object Pin
Richard Blythe8-Jul-08 5:07
Richard Blythe8-Jul-08 5:07 
AnswerRe: Communicating via Windows Service object Pin
Pete O'Hanlon8-Jul-08 8:56
mvePete O'Hanlon8-Jul-08 8:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.