All, It appears that my connection string to oracle requires a service_name or sid. When I try to use it in my connection string via dbmetal I get the following error from dbmetal:
dbmetal - keyword sid not supported or... dbmetal - keyword service_name not supported my connection string I am passing to dbmetal looks like this: c:\dblinq\dbmetal -- conn="Server=my_server;sid=my_service_name;Uid=my_username;Pwd=my_password" --database=my_database --provider=Oracle --code="c:\dblinq\linq.cs" How can I get dbmetal to accept a sid or service name parameter in the connection string? Thanks! /Justin Justin wrote: > All, > > I am using this syntax to generate a .cs file for my oracle schema but > no tables are being generated. Am I missing something? > > c:\dblinq\dbmetal -- > conn="Server=my_server;Uid=my_server;Pwd=my_password" -- > database=my_database --provider=Oracle --code="c:\dblinq\linq.cs" > > the linq.cs file is generated, but no tables are in it at all. > > Here is what is generated in the linq.cs file... > > // > // ____ _ __ __ _ _ > // | _ \| |__ | \/ | ___| |_ __ _| | > // | | | | '_ \| |\/| |/ _ \ __/ _` | | > // | |_| | |_) | | | | __/ || (_| | | > // |____/|_.__/|_| |_|\___|\__\__,_|_| > // > // Auto-generated from my_database on 2010-10-21 13:55:07Z. > // Please visit http://code.google.com/p/dblinq2007/ for more > information. > // > using System; > using System.ComponentModel; > using System.Data; > #if MONO_STRICT > using System.Data.Linq; > #else // MONO_STRICT > using DbLinq.Data.Linq; > using DbLinq.Vendor; > #endif // MONO_STRICT > using System.Data.Linq.Mapping; > using System.Diagnostics; > > > public partial class my_database : DataContext > { > > #region Extensibility Method Declarations > partial void OnCreated(); > #endregion > > > public my_database(string connectionString) : > base(connectionString) > { > this.OnCreated(); > } > > public my_database(string connection, MappingSource mappingSource) : > base(connection, mappingSource) > { > this.OnCreated(); > } > > public my_database(IDbConnection connection, MappingSource > mappingSource) : > base(connection, mappingSource) > { > this.OnCreated(); > } > } > > #region Start MONO_STRICT > #if MONO_STRICT > > public partial class my_database > { > > public my_database(IDbConnection connection) : > base(connection) > { > this.OnCreated(); > } > } > #region End MONO_STRICT > #endregion > #else // MONO_STRICT > > public partial class my_database > { > > public my_database(IDbConnection connection) : > base(connection, new DbLinq.Oracle.OracleVendor()) > { > this.OnCreated(); > } > > public my_database(IDbConnection connection, IVendor sqlDialect) : > base(connection, sqlDialect) > { > this.OnCreated(); > } > > public my_database(IDbConnection connection, MappingSource > mappingSource, IVendor sqlDialect) : > base(connection, mappingSource, sqlDialect) > { > this.OnCreated(); > } > } > #region End Not MONO_STRICT > #endregion > #endif // MONO_STRICT > #endregion -- You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/dblinq?hl=en.
