Elsasoft Forums
Elsasoft Forums
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SqlSpec
 Other
 Connection string to add comments
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dbadoc
Starting Member

10 Posts

Posted - Nov 30 2010 :  12:11:15 PM  Show Profile  Reply with Quote
How do I access a particular schema's table so that I can edit the properties in oracle? I have the following connect string:

Provider=OraOLEDB.Oracle;Data Source=instancename;User Id=username;Password=userpassword

But I get the tables from a different schema.

Thanks!
Laura

Jesse
Forum Admin

732 Posts

Posted - Nov 30 2010 :  1:03:16 PM  Show Profile  Reply with Quote
you should get the tables in the username schema in this case. Is that what you get?
Go to Top of Page

dbadoc
Starting Member

10 Posts

Posted - Dec 03 2010 :  08:12:45 AM  Show Profile  Reply with Quote
Yes that worked to access the schema. New question, though, when I click "script" to generate the script, the syntax does not end each comment with a semicolon which results in a sql command not properly ended error. Is there a patch for this issue?
Go to Top of Page

Jesse
Forum Admin

732 Posts

Posted - Dec 03 2010 :  08:29:12 AM  Show Profile  Reply with Quote
no patch currently, but I'll fix that. I'll post back here when fixed.
Go to Top of Page

Jesse
Forum Admin

732 Posts

Posted - Dec 06 2010 :  9:14:30 PM  Show Profile  Reply with Quote
>> when I click "script" to generate the script, the syntax does not end each comment with a semicolon which results in a sql command not properly ended error. Is there a patch for this issue?

this is fixed in the current beta.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Elsasoft Forums © Elsasoft LLC Go To Top Of Page
Snitz Forums 2000